Get Sheet ID By Name
Description
Google Spreadsheets: Get Sheet ID By Name step, gets the sheet Id of the provided sheet name from a spreadsheet on Google drive.
Configurations
| No. | Field Name | Description |
|---|---|---|
| 1 | Step name | Name of the step as it appears in the workflow workspace. This name has to be unique in a single workflow. |
| Connection: | Refer Prerequisites and References above to get the connection attributes. | |
| 2 | Client ID | Specify Client ID of the Google application. The data type is String. This field is mandatory. |
| Client Secret: | ||
| 3 | Accept Values from fields | Leave checkbox unchecked to accept Client Secret value from a field in the previous steps of the stream using a drop down list. Else enable checkbox for Secret Key field to appear as Text box. |
| 4 | Client Secret | Specify Client Secret of the Google application. If checkbox above is enabled Client Secret field appears as Text box and accepts static values or variables. Else if checkbox above is disabled Client Secret field appears as a drop down containing values from previous steps - to select from.The data type is String. This field is mandatory. |
| Refresh Token: | ||
| 5 | Accept Values from fields | Leave checkbox unchecked to accept Secret Key value from a field in the previous steps of the stream using a drop down list. Else enable checkbox for Secret Key field to appear as Text box. |
| 6 | Refresh Token | Specify a Refresh Token to obtain a new Access Token. Note: Refresh Token expires if idle for 6 months. If checkbox above is enabled Refresh Token field appears as Text box and accepts static values or variables. Else if checkbox above is disabled Refresh Token field appears as a drop down containing values from previous steps - to select from. The data type is String. This field is mandatory. |
| 7 | Button: Test Connection | Verifies whether the connection is established or not. Note: For the purpose of verification fields coming from previous steps are not allowed since field values can only be accessed when workflow is in running state; only static values and environment variables are allowed. |
| Input Fields: | ||
| 1 | Spreadsheet ID | Specify a Spreadsheet ID of the spreadsheet on which the sheet is present. The data type is String. This field is mandatory. Note:To get a spreadsheet ID: In the URL, the spreadsheet ID is the value between "/d/" and "/edit" in the URL of the spreadsheet, as shown in the following image:  For example, consider the following URL that refers a Google Sheets spreadsheet: https://docs.google.com/spreadsheets/d/1CJnkal5pj3SLpv-HdmyguX/edit#gid=0 Then the Spreadsheet ID is 1CJnkal5pj3SLpv- HdmyguX. |
| 2 | Sheet Name | Specify the Sheet name to fetch its sheet ID, or click the Get button as mentioned below.The data type is String. This field is mandatory. |
| 3 | Button: Get | Click the Get button to get the list of sheet names in the Spreadsheet. |
| Output Field | ||
| 1 | Sheet ID | Specify an output field to hold the returned Sheet ID. The date type is string. This field is mandatory. |